{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Spenddown","Medical Expenses","Instructions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Spenddown","index":0,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[22,0,22,1],[9,8,14,8],[7,0,7,6],[9,6,14,6],[9,7,14,7]]}
[]
[]
[]
[]
["Case Number"]
["Case Name"]
[]
["New  Medical Base Period  "]
["Base Period Month","Total Earned Income","Earned Income After All Disregards","Total Unearned Income","Unearned Income After All Disregards","Countable Income (Less PIL)","Spenddown Amount","Expenses","Remaining Spenddown Amount"]
[null,null,{"$f":"MAX((A17 - 65)/2,0)","v":0},null,{"$f":"D10-20","v":-20},{"$f":"MAX(C10+E10-$B$25,0)","v":0},{"$f":"MAX(SUM($F$10:$F$15),0)","v":0},{"$f":"'Medical Expenses'!F22","v":0},{"$f":"MAX(G10-H10,0)","v":0}]
[null,null,{"$f":"MAX((B17 - 65)/2,0)","v":0},null,{"$f":"D11-20","v":-20},0]
[null,null,{"$f":"MAX((C17 - 65)/2,0)","v":0},null,-20,0]
[null,null,{"$f":"MAX((D17 - 65)/2,0)","v":0},null,-20,0]
[null,null,{"$f":"MAX((E17 - 65)/2,0)","v":0},null,-20,0]
[null,null,{"$f":"MAX((F17 - 65)/2,0)","v":0},null,-20,0]
[]
[{"$f":"(B10-D21)","v":0},{"$f":"(B11-E21)","v":0},{"$f":"(B12-F21)","v":0},{"$f":"(B13-G21)","v":0},{"$f":"(B14-H21)","v":0},{"$f":"(B15-I21)","v":0}]
[]
["IRWE or BWE",null,null,{"$f":"IF(A10=\"\", \"Month 1\", A10)","v":"Month 1"},{"$f":"IF(A11=\"\", \"Month 2\", A11)","v":"Month 2"},{"$f":"IF(A12=\"\", \"Month 3\", A12)","v":"Month 3"},{"$f":"IF(A13=\"\", \"Month 4\", A13)","v":"Month 4"},{"$f":"IF(A14=\"\", \"Month 5\", A14)","v":"Month 5"},{"$f":"IF(A15=\"\", \"Month 6\", A15)","v":"Month 6"}]
[null,null,"Reported Amount"]
[null,null,"Deduction",{"$f":"MAX(D20,IF(A20=\"IRWE\",100,IF(A20=\"BWE\",300,IF(A20=\"Actuals\",0,0))))","v":0},{"$f":"MAX(E20, IF(A20=\"IRWE\",100, IF(A20=\"BWE\",300, IF(A20=\"Actuals\",0,0))))","v":0},{"$f":"MAX(F20, IF(A20=\"IRWE\",100, IF(A20=\"BWE\",300, IF(A20=\"Actuals\",0,0))))","v":0},{"$f":"MAX(G20, IF(A20=\"IRWE\",100, IF(A20=\"BWE\",300, IF(A20=\"Actuals\",0,0))))","v":0},{"$f":"MAX(H20, IF(A20=\"IRWE\",100, IF(A20=\"BWE\",300, IF(A20=\"Actuals\",0,0))))","v":0},{"$f":"MAX(I20, IF(A20=\"IRWE\",100, IF(A20=\"BWE\",300, IF(A20=\"Actuals\",0,0))))","v":0}]
[]
["Independent Living Protected Income Limits (PIL) for One Month"]
["Household Size","1 or 2 persons"]
["PIL",475]

{"sheet":"Medical Expenses","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,3,0,4],[1,3,1,4],[2,3,2,4],[3,0,3,5]]}
["Case Number",{"$f":"IF(Spenddown!$B$5 = \"\", \"\", Spenddown!$B$5)","v":""},null,"Base Period",null,"Current"]
["Case Name",{"$f":"IF(Spenddown!$B$6 = \"\", \"\", Spenddown!$B$6)","v":""},null,"Initial Spenddown",null,{"$f":"Spenddown!G10","v":0}]
[null,null,null,"Remaining Spenddown",null,{"$f":"MAX($F$2 - $F$22,0)","v":0}]
[]
["Role\n(MEM/FRI)","Name","Provider Information","Date of Service","Total Charge","Client\nObligation"]
[]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[null,null,null,"Total",{"$f":"SUM(E6:E21)","v":0},{"$f":"SUM(F6:F21)","v":0}]

{"sheet":"Instructions","index":2,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,12],[1,0,49,12]]}
["Spenddown Estimator Tool"]
["Overview:  The Spenddown Estimator Tool is used when estimating a potential spenddown for E&D programs.  \n\nGeneral Instructions\nEnter the Case Name and Case Number at the top of the Spenddown Worksheet.  This information will automatically populate onto the Medical Expenses tab.  \n\nUsers will enter the Total Earned Income and Total Unearned Income to calculate the Spenddown Amount.  The Protected Income Limit is automatically generated. Use the IRWE or BWE dropdown if one of these is to be applied. Then, enter the actual expense amount in the Reported Amount field. This populates the spenddown amount, the amount the consumer will have to meet before any expenses are applied.\n\nOnce expenses are applied using the Medical Expenses tab, the amount will update in the Remaining Spenddown Amount field.  \n\nEntering Medical Expenses:  Data collected on this tab will assist the worker in calculating the Remaining Spenddown once expenses have been applied.  Each expense will be added to the worksheet by entering the Role, Name (of the person the expense is for), Provider Information, Date of Service, Total Charge, and Client Obligation.  Only the Client Obligation amount will be deducted from the Initial Spenddown.  The total Client Obligation will then feed automatically into the Spenddown tab under Expenses.  \n\nBoth tabs of the Spenddown Worksheet will need to be imaged to the KEES case.  \n"]